﻿14.4.2013 22:05:44
select * from [User] where nameLogin = @nameLogin and password = @password

14.4.2013 22:05:44
INSERT INTO Login ( idUser, 
login, 
idApplication) VALUES (  1, 
 to_date('14.4.2013 22:05:44', 'dd/mm/yyyy hh24:mi:ss'), 
 1) ; SELECT @@Identity

14.4.2013 22:05:44
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

14.4.2013 22:05:47
UPDATE Login SET 
logout = to_date('14.4.2013 22:05:47', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idLogin = 335 

18.4.2013 10:43:23
select * from [User] where nameLogin = @nameLogin and password = @password

18.4.2013 10:43:25
INSERT INTO Login ( idUser, 
login, 
idApplication) VALUES (  1, 
 to_date('18.4.2013 10:43:25', 'dd/mm/yyyy hh24:mi:ss'), 
 1) ; SELECT @@Identity

18.4.2013 10:43:26
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

18.4.2013 10:43:29
select * from role order by name

18.4.2013 10:43:29
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

18.4.2013 10:43:43
select * from role order by name

18.4.2013 10:43:54
UPDATE [User] SET 
idRole = 5
 WHERE idUser = 5 

18.4.2013 10:43:54
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

18.4.2013 10:43:59
select [USER].*, Role.name as RoleName 
from [USER] 
left join Role on Role.idRole = [USER].idRole

18.4.2013 10:43:59
select * from company order by name

18.4.2013 10:44:00
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

18.4.2013 10:44:00
select * from role order by name

18.4.2013 10:44:10
select [USER].*, Role.name as RoleName 
from [USER] 
left join Role on Role.idRole = [USER].idRole

18.4.2013 10:44:10
select * from company order by name

18.4.2013 10:44:15
select * from role order by name

18.4.2013 10:44:16
select top 0  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

18.4.2013 10:44:16
select  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

18.4.2013 10:44:16
--DECLARE 1 int = 1; 
select 
Rights.idRights,
Modul.idModul, Modul.nameModul, 
Rights.idRole, 
Rights.idModul as idModulRights, 
ISNULL(Rights.visible, 1) as visible, 
ISNULL(Rights.adding, 1) as adding, 
ISNULL(Rights.edit, 1) as edit,  
ISNULL(Rights.remove, 1) as remove, 
ISNULL(Rights.printing, 1) as printing,  
ISNULL(Rights.specialFiltration, 1) as specialFiltration 
from Modul 
left join Rights on Modul.idModul = Rights.idModul 
where Rights.idRole = 1 
order by modul.nameModul

18.4.2013 10:44:16
select * from role order by name

18.4.2013 10:44:18
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

18.4.2013 10:44:18
select * from role order by name

18.4.2013 10:50:45
select * from [User] where nameLogin = @nameLogin and password = @password

18.4.2013 10:50:45
INSERT INTO Login ( idUser, 
login, 
idApplication) VALUES (  1, 
 to_date('18.4.2013 10:50:45', 'dd/mm/yyyy hh24:mi:ss'), 
 1) ; SELECT @@Identity

18.4.2013 10:50:45
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

18.4.2013 10:50:47
select * from role order by name

18.4.2013 10:50:47
select * from role order by name

18.4.2013 10:50:47
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

18.4.2013 10:50:52
select [USER].*, Role.name as RoleName 
from [USER] 
left join Role on Role.idRole = [USER].idRole

18.4.2013 10:50:52
select * from company order by name

18.4.2013 10:50:54
select * from role order by name

18.4.2013 10:50:54
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

18.4.2013 10:51:03
select * from role order by name

18.4.2013 10:51:04
select top 0  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

18.4.2013 10:51:04
select  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

18.4.2013 10:51:04
--DECLARE 1 int = 1; 
select 
Rights.idRights,
Modul.idModul, Modul.nameModul, 
Rights.idRole, 
Rights.idModul as idModulRights, 
ISNULL(Rights.visible, 1) as visible, 
ISNULL(Rights.adding, 1) as adding, 
ISNULL(Rights.edit, 1) as edit,  
ISNULL(Rights.remove, 1) as remove, 
ISNULL(Rights.printing, 1) as printing,  
ISNULL(Rights.specialFiltration, 1) as specialFiltration 
from Modul 
left join Rights on Modul.idModul = Rights.idModul 
where Rights.idRole = 1 
order by modul.nameModul

18.4.2013 10:51:04
select * from role order by name

18.4.2013 10:51:14
select top 0  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

18.4.2013 10:51:14
select  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

18.4.2013 10:51:14
--DECLARE 2 int = 1; 
select 
Rights.idRights,
Modul.idModul, Modul.nameModul, 
Rights.idRole, 
Rights.idModul as idModulRights, 
ISNULL(Rights.visible, 1) as visible, 
ISNULL(Rights.adding, 1) as adding, 
ISNULL(Rights.edit, 1) as edit,  
ISNULL(Rights.remove, 1) as remove, 
ISNULL(Rights.printing, 1) as printing,  
ISNULL(Rights.specialFiltration, 1) as specialFiltration 
from Modul 
left join Rights on Modul.idModul = Rights.idModul 
where Rights.idRole = 2 
order by modul.nameModul

18.4.2013 10:51:23
select [USER].*, Role.name as RoleName 
from [USER] 
left join Role on Role.idRole = [USER].idRole

18.4.2013 10:51:23
select * from company order by name

18.4.2013 10:51:25
select * from role order by name

18.4.2013 10:51:25
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

18.4.2013 10:51:28
select [USER].*, Role.name as RoleName 
from [USER] 
left join Role on Role.idRole = [USER].idRole

18.4.2013 10:51:28
select * from company order by name

18.4.2013 10:51:29
select * from company order by name

18.4.2013 10:51:30
select * from role order by name

18.4.2013 10:51:30
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

18.4.2013 10:51:31
select [USER].*, Role.name as RoleName 
from [USER] 
left join Role on Role.idRole = [USER].idRole

18.4.2013 10:51:31
select * from company order by name

18.4.2013 10:51:31
select * from company order by name

18.4.2013 10:51:32
select * from role order by name

18.4.2013 10:51:32
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

18.4.2013 10:51:37
UPDATE [User] SET 
idRole = 2
 WHERE idUser = 5 

18.4.2013 10:51:37
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

18.4.2013 10:51:42
select [USER].*, Role.name as RoleName 
from [USER] 
left join Role on Role.idRole = [USER].idRole

18.4.2013 10:51:42
select * from company order by name

18.4.2013 10:51:42
select * from company order by name

18.4.2013 10:51:43
select * from role order by name

18.4.2013 10:51:43
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

18.4.2013 10:51:48
select [USER].*, Role.name as RoleName 
from [USER] 
left join Role on Role.idRole = [USER].idRole

18.4.2013 10:51:48
select * from company order by name

18.4.2013 10:51:48
select * from company order by name

18.4.2013 10:51:49
select * from role order by name

18.4.2013 10:51:49
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

18.4.2013 10:51:56
select [USER].*, Role.name as RoleName 
from [USER] 
left join Role on Role.idRole = [USER].idRole

18.4.2013 10:51:56
select * from company order by name

18.4.2013 10:51:56
select * from company order by name

18.4.2013 10:51:58
select * from company order by name

18.4.2013 10:53:43
UPDATE [User] SET 
IdCompany = 4, 
 Notes = 'Zaměstnanec roku.', 
 Phone = '756 245', 
 Email = 'alKopecky@seznam.cz', 
 Address = 'Na Letné 40', 
 NameLogin = 'Alfonz', 
 Password = 'garage', 
 Name = 'Alfonz', 
 Surname = 'Kopecký'
 WHERE idUser = 5 

18.4.2013 10:53:43
select [USER].*, Role.name as RoleName 
from [USER] 
left join Role on Role.idRole = [USER].idRole

18.4.2013 10:53:43
select * from company order by name

18.4.2013 10:53:43
select * from company order by name

18.4.2013 10:53:51
select * from company order by name

18.4.2013 10:53:53
select * from company order by name

18.4.2013 10:54:02
select * from role order by name

18.4.2013 10:54:02
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

18.4.2013 10:54:03
select [USER].*, Role.name as RoleName 
from [USER] 
left join Role on Role.idRole = [USER].idRole

18.4.2013 10:54:03
select * from company order by name

18.4.2013 10:54:03
select * from company order by name

18.4.2013 10:54:04
select * from company order by name

18.4.2013 10:54:05
select * from company order by name

18.4.2013 10:54:06
select * from company order by name

18.4.2013 10:54:07
select * from company order by name

18.4.2013 10:54:17
UPDATE [User] SET 
IdCompany = 4, 
 Notes = 'Zaměstnanec roku.', 
 Phone = '756 245 342', 
 Email = 'alKopecky@seznam.cz', 
 Address = 'Na Letné 40', 
 NameLogin = 'Alfonz', 
 Password = 'garage', 
 Name = 'Alfonz', 
 Surname = 'Kopecký'
 WHERE idUser = 5 

18.4.2013 10:54:17
select [USER].*, Role.name as RoleName 
from [USER] 
left join Role on Role.idRole = [USER].idRole

18.4.2013 10:54:17
select * from company order by name

18.4.2013 10:54:17
select * from company order by name

18.4.2013 10:54:18
select * from company order by name

18.4.2013 10:54:19
select * from company order by name

18.4.2013 10:54:21
select * from company order by name

18.4.2013 10:54:31
select * from company order by name

18.4.2013 10:54:34
select * from company order by name

18.4.2013 10:56:10
UPDATE [User] SET 
IdCompany = 3, 
 Notes = 'Testování Ján Kupec - průzkumník.', 
 Phone = '', 
 Email = '', 
 Address = '', 
 NameLogin = 'Honza', 
 Password = 'kokos', 
 Name = 'Ján', 
 Surname = 'Kupec'
 WHERE idUser = 4 

18.4.2013 10:56:10
select [USER].*, Role.name as RoleName 
from [USER] 
left join Role on Role.idRole = [USER].idRole

18.4.2013 10:56:10
select * from company order by name

18.4.2013 10:56:10
select * from company order by name

18.4.2013 10:56:12
select * from company order by name

18.4.2013 10:56:13
select * from company order by name

18.4.2013 10:56:19
select * from role order by name

18.4.2013 13:02:36
select * from [User] where nameLogin = @nameLogin and password = @password

18.4.2013 13:02:36
INSERT INTO Login ( idUser, 
login, 
idApplication) VALUES (  1, 
 to_date('18.4.2013 13:02:36', 'dd/mm/yyyy hh24:mi:ss'), 
 1) ; SELECT @@Identity

18.4.2013 13:02:36
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

18.4.2013 13:02:38
select * from role order by name

18.4.2013 13:02:38
select top 0  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

18.4.2013 13:02:38
select  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

18.4.2013 13:02:38
--DECLARE 1 int = 1; 
select 
Rights.idRights,
Modul.idModul, Modul.nameModul, 
Rights.idRole, 
Rights.idModul as idModulRights, 
ISNULL(Rights.visible, 1) as visible, 
ISNULL(Rights.adding, 1) as adding, 
ISNULL(Rights.edit, 1) as edit,  
ISNULL(Rights.remove, 1) as remove, 
ISNULL(Rights.printing, 1) as printing,  
ISNULL(Rights.specialFiltration, 1) as specialFiltration 
from Modul 
left join Rights on Modul.idModul = Rights.idModul 
where Rights.idRole = 1 
order by modul.nameModul

18.4.2013 13:02:38
select * from role order by name

18.4.2013 13:02:43
UPDATE Rights SET 
visible = 0, 
 adding = 1, 
 edit = 1, 
 remove = 1, 
 printing = 1, 
 specialFiltration = 1
 WHERE idRights = 1 

18.4.2013 13:02:50
select top 0  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

18.4.2013 13:02:50
select  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

18.4.2013 13:02:50
--DECLARE 1 int = 1; 
select 
Rights.idRights,
Modul.idModul, Modul.nameModul, 
Rights.idRole, 
Rights.idModul as idModulRights, 
ISNULL(Rights.visible, 1) as visible, 
ISNULL(Rights.adding, 1) as adding, 
ISNULL(Rights.edit, 1) as edit,  
ISNULL(Rights.remove, 1) as remove, 
ISNULL(Rights.printing, 1) as printing,  
ISNULL(Rights.specialFiltration, 1) as specialFiltration 
from Modul 
left join Rights on Modul.idModul = Rights.idModul 
where Rights.idRole = 1 
order by modul.nameModul

18.4.2013 13:02:51
select top 0  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

18.4.2013 13:02:51
select  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

18.4.2013 13:02:51
--DECLARE 1 int = 1; 
select 
Rights.idRights,
Modul.idModul, Modul.nameModul, 
Rights.idRole, 
Rights.idModul as idModulRights, 
ISNULL(Rights.visible, 1) as visible, 
ISNULL(Rights.adding, 1) as adding, 
ISNULL(Rights.edit, 1) as edit,  
ISNULL(Rights.remove, 1) as remove, 
ISNULL(Rights.printing, 1) as printing,  
ISNULL(Rights.specialFiltration, 1) as specialFiltration 
from Modul 
left join Rights on Modul.idModul = Rights.idModul 
where Rights.idRole = 1 
order by modul.nameModul

18.4.2013 13:02:53
select top 0  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

18.4.2013 13:02:53
select  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

18.4.2013 13:02:53
--DECLARE 2 int = 1; 
select 
Rights.idRights,
Modul.idModul, Modul.nameModul, 
Rights.idRole, 
Rights.idModul as idModulRights, 
ISNULL(Rights.visible, 1) as visible, 
ISNULL(Rights.adding, 1) as adding, 
ISNULL(Rights.edit, 1) as edit,  
ISNULL(Rights.remove, 1) as remove, 
ISNULL(Rights.printing, 1) as printing,  
ISNULL(Rights.specialFiltration, 1) as specialFiltration 
from Modul 
left join Rights on Modul.idModul = Rights.idModul 
where Rights.idRole = 2 
order by modul.nameModul

18.4.2013 13:02:55
select top 0  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

18.4.2013 13:02:55
select  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

18.4.2013 13:02:55
--DECLARE 5 int = 1; 
select 
Rights.idRights,
Modul.idModul, Modul.nameModul, 
Rights.idRole, 
Rights.idModul as idModulRights, 
ISNULL(Rights.visible, 1) as visible, 
ISNULL(Rights.adding, 1) as adding, 
ISNULL(Rights.edit, 1) as edit,  
ISNULL(Rights.remove, 1) as remove, 
ISNULL(Rights.printing, 1) as printing,  
ISNULL(Rights.specialFiltration, 1) as specialFiltration 
from Modul 
left join Rights on Modul.idModul = Rights.idModul 
where Rights.idRole = 5 
order by modul.nameModul

18.4.2013 13:03:01
select * from role order by name

18.4.2013 13:03:01
select * from role order by name

18.4.2013 13:03:01
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

18.4.2013 13:03:02
select * from role order by name

18.4.2013 13:03:04
select * from role order by name

18.4.2013 13:03:04
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

18.4.2013 13:03:10
UPDATE [User] SET 
idRole = 3
 WHERE idUser = 5 

18.4.2013 13:03:10
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

18.4.2013 13:03:15
select [USER].*, Role.name as RoleName 
from [USER] 
left join Role on Role.idRole = [USER].idRole

18.4.2013 13:03:15
select * from company order by name

18.4.2013 13:03:16
select * from role order by name

18.4.2013 13:03:16
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

18.4.2013 13:03:19
select [USER].*, Role.name as RoleName 
from [USER] 
left join Role on Role.idRole = [USER].idRole

18.4.2013 13:03:19
select * from company order by name

18.4.2013 13:03:21
select * from company order by name

18.4.2013 13:03:23
select * from company order by name

18.4.2013 13:04:03
UPDATE [User] SET 
IdCompany = 3, 
 Notes = 'Testování Ján Kupec - průzkumník.', 
 Phone = '585 478 246', 
 Email = 'kupecJan@gmail.com', 
 Address = 'Purkinova 5, Košice', 
 NameLogin = 'Honza', 
 Password = 'kokos', 
 Name = 'Ján', 
 Surname = 'Kupec'
 WHERE idUser = 4 

18.4.2013 13:04:03
select [USER].*, Role.name as RoleName 
from [USER] 
left join Role on Role.idRole = [USER].idRole

18.4.2013 13:04:03
select * from company order by name

18.4.2013 13:04:03
select * from company order by name

18.4.2013 13:04:06
select * from company order by name

18.4.2013 13:04:07
select * from company order by name

18.4.2013 13:04:19
select * from role order by name

18.4.2013 13:04:19
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

18.4.2013 13:04:23
select * from role order by name

18.4.2013 13:04:30
UPDATE Rights SET 
visible = 1, 
 adding = 1, 
 edit = 1, 
 remove = 1, 
 printing = 1, 
 specialFiltration = 1
 WHERE idRights = 1 

18.4.2013 13:04:35
UPDATE Login SET 
logout = to_date('18.4.2013 13:04:35', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idLogin = 340 

18.4.2013 14:39:19
select * from [User] where nameLogin = @nameLogin and password = @password

18.4.2013 14:39:20
INSERT INTO Login ( idUser, 
login, 
idApplication) VALUES (  1, 
 to_date('18.4.2013 14:39:20', 'dd/mm/yyyy hh24:mi:ss'), 
 1) ; SELECT @@Identity

18.4.2013 14:39:20
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

18.4.2013 14:39:22
select * from role order by name

18.4.2013 14:39:22
select top 0  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

18.4.2013 14:39:22
select  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

18.4.2013 14:39:22
--DECLARE 1 int = 1; 
select 
Rights.idRights,
Modul.idModul, Modul.nameModul, 
Rights.idRole, 
Rights.idModul as idModulRights, 
ISNULL(Rights.visible, 1) as visible, 
ISNULL(Rights.adding, 1) as adding, 
ISNULL(Rights.edit, 1) as edit,  
ISNULL(Rights.remove, 1) as remove, 
ISNULL(Rights.printing, 1) as printing,  
ISNULL(Rights.specialFiltration, 1) as specialFiltration 
from Modul 
left join Rights on Modul.idModul = Rights.idModul 
where Rights.idRole = 1 
order by modul.nameModul

18.4.2013 14:39:22
select * from role order by name

18.4.2013 14:39:24
select * from role order by name

18.4.2013 14:39:24
select * from role order by name

18.4.2013 14:39:24
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

18.4.2013 14:39:29
UPDATE [User] SET 
idRole = 5
 WHERE idUser = 5 

18.4.2013 14:39:29
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

18.4.2013 14:39:36
select [USER].*, Role.name as RoleName 
from [USER] 
left join Role on Role.idRole = [USER].idRole

18.4.2013 14:39:36
select * from company order by name

18.4.2013 14:39:37
select * from role order by name

18.4.2013 14:39:37
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

18.4.2013 14:39:41
UPDATE [User] SET 
idRole = 3
 WHERE idUser = 5 

18.4.2013 14:39:41
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

18.4.2013 14:39:43
select [USER].*, Role.name as RoleName 
from [USER] 
left join Role on Role.idRole = [USER].idRole

18.4.2013 14:39:43
select * from company order by name

18.4.2013 14:39:44
select * from role order by name

18.4.2013 14:39:44
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

18.4.2013 14:39:45
select [USER].*, Role.name as RoleName 
from [USER] 
left join Role on Role.idRole = [USER].idRole

18.4.2013 14:39:45
select * from company order by name

18.4.2013 14:39:46
select * from role order by name

18.4.2013 14:39:46
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

18.4.2013 14:39:51
UPDATE Login SET 
logout = to_date('18.4.2013 14:39:51', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idLogin = 341 

